import pandas as pd
import logging
import sys

logging.basicConfig(level=logging.INFO)
fileUrl="tttt.xlsx"
testUrl="test.xlsx"

df_110022={'日增长率':"test"}
try:
    df_110022 = pd.read_excel(fileUrl,sheet_name='110022')
    df_110022['date'] = pd.to_datetime(df_110022['发布日期'])
    df_110022.set_index('date',inplace=True)
    df_110022['日增长率'] = df_110022['日增长率'].str.strip('%').astype(float);
    df_110022.sort_index(ascending=True,inplace=True)
except FileNotFoundError as e:
    logging.info('file path = %s' % sys.executable)

def apprun():
    print(df_110022['日增长率'])
    return df_110022['日增长率']


if __name__ == '__main__':
    apprun()

